{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Part of this file can't be rendered in GitHub. Refer to the following link for a properly rendered version of this file: https://nbviewer.jupyter.org/github/sfu-db/dataprep/blob/develop/examples/DataConnector_DBLP.ipynb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Connector for DBLP \n",
    "\n",
    "In this example, we will be going over how to use Connector with DBLP."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Prerequisites\n",
    "\n",
    "Connector is a component in the DataPrep library that aims to simplify data access by providing a standard API set. The goal is to help users skip the complex API configuration. In this tutorial, we demonstrate how to use the connector component with DBLP.\n",
    "\n",
    "If you haven't installed DataPrep, run command `!pip install dataprep` or execute the following cell."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Run me if you'd like to install\n",
    "!pip install dataprep"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The code below gives you a peek what data is available behind the DBLP API."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<html>\n",
       "    <head>\n",
       "        <title> DataPrep.Connector Info </title>\n",
       "        <script>\n",
       "            function switchTab637(e) {\n",
       "                const selectedAreaSuffix = e.parentElement.parentElement.className.split('-')[1];\n",
       "                const selectedTabId = e.id.split('-')[2];\n",
       "                const selectedTabContent = document.querySelector(`.contents-${selectedAreaSuffix}>div:nth-of-type(${selectedTabId})`);\n",
       "                const contentArray = document.getElementsByClassName('info-637')\n",
       "                for (let i of contentArray) {\n",
       "                    i.style.display = 'none';\n",
       "                }\n",
       "                selectedTabContent.style.display = 'block';\n",
       "            }\n",
       "        </script>\n",
       "        <style>\n",
       "            .container-637 {\n",
       "            }\n",
       "            .container-637 input[type=radio] {\n",
       "            display: none;\n",
       "            }\n",
       "            .tabs-637 {\n",
       "            font-family: -apple-system, 'Helvetica Neue', 'Helvetica', 'Arial', 'Lucida Grande', sans-serif;\n",
       "            -webkit-font-smoothing: antialiased;\n",
       "            display: grid;\n",
       "            flex-wrap: wrap;\n",
       "            gap: 5px;\n",
       "            grid-template-columns: repeat(auto-fill, minmax(110px, 1fr));\n",
       "            justify-content: wrap;\n",
       "            }\n",
       "            .tabs-637 label {\n",
       "            word-wrap: break-word;\n",
       "            text-align: center;\n",
       "            font-size: 12px;\n",
       "            border-bottom: 2px solid #9edae5;\n",
       "            transition: border 0.3s ease;\n",
       "            }\n",
       "            .tabs-637 label:hover {\n",
       "            background: rgba(0, 0, 0, 0.1);\n",
       "            }\n",
       "            .tabs-637 input:checked+label {\n",
       "            border-bottom: 2px solid #1f77b4;\n",
       "            }\n",
       "            .contents-637>div:nth-of-type(n+2) {\n",
       "            display: none;\n",
       "            }\n",
       "            h4 {\n",
       "            font-size: 14px;\n",
       "            font-family: Arial;\n",
       "            }\n",
       "            p {\n",
       "            font-size: 13px;\n",
       "            }\n",
       "        </style>\n",
       "    </head>\n",
       "    <body>\n",
       "        <div class=\"container-637\">\n",
       "            <div class=\"tabs-637\">\n",
       "                <input type=\"radio\" name=\"select\" id='tab-637-1' checked onclick=\"switchTab637(this)\">\n",
       "                <label for=\"tab-637-1\">publication</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    \t\t\n",
       "            </div>\n",
       "            <div class=\"contents-637\">\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>q (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>h</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>f</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('dblp')<br>df = await dc.query('publication', q='lee', _count=20)</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_b78d2e74_8140_11eb_b0c3_acde48001122 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_b78d2e74_8140_11eb_b0c3_acde48001122 td {\n",
       "          font-family: arial;\n",
       "    }    #T_b78d2e74_8140_11eb_b0c3_acde48001122 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_b78d2e74_8140_11eb_b0c3_acde48001122 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_b78d2e74_8140_11eb_b0c3_acde48001122 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row0_col0\" class=\"data row0 col0\" >title</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row1_col0\" class=\"data row1 col0\" >venue</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row1_col1\" class=\"data row1 col1\" >object</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row2_col0\" class=\"data row2 col0\" >publisher</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row3_col0\" class=\"data row3 col0\" >year</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row4_col0\" class=\"data row4 col0\" >type</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row5_col0\" class=\"data row5 col0\" >key</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row6_col0\" class=\"data row6 col0\" >ee</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row7_col0\" class=\"data row7 col0\" >url</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row8_col0\" class=\"data row8 col0\" >authors</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row8_col1\" class=\"data row8 col1\" >object</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row9_col0\" class=\"data row9 col0\" >pages</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row9_col1\" class=\"data row9 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122level0_row10\" class=\"row_heading level0 row10\" >10</th>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row10_col0\" class=\"data row10 col0\" >doi</td>\n",
       "                        <td id=\"T_b78d2e74_8140_11eb_b0c3_acde48001122row10_col1\" class=\"data row10 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "            </div>\n",
       "        </div>\n",
       "    </body>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from dataprep.connector import info as info\n",
    "info('dblp')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Download and store the configuration files in DataPrep. \n",
    "\n",
    "The configuration files are used to configure the parameters and initial setup for the API. \n",
    "You will use the configuration files here [Configuration Files](https://github.com/sfu-db/DataConnectorConfigs) by default.\n",
    "The configuration files can be manually downloaded and modified.\n",
    "You can specify the directoty of the configuration files using \"config_path\" parameter."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Initialize connector\n",
    "\n",
    "To initialize, run the following code. To fetch DBLP data, tokens and client information are not needed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>venue</th>\n",
       "      <th>publisher</th>\n",
       "      <th>year</th>\n",
       "      <th>type</th>\n",
       "      <th>key</th>\n",
       "      <th>ee</th>\n",
       "      <th>url</th>\n",
       "      <th>authors</th>\n",
       "      <th>pages</th>\n",
       "      <th>doi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020 IEEE/CVF Conference on Computer Vision an...</td>\n",
       "      <td>[CVPR]</td>\n",
       "      <td>IEEE</td>\n",
       "      <td>2020</td>\n",
       "      <td>Editorship</td>\n",
       "      <td>conf/cvpr/2020</td>\n",
       "      <td>https://ieeexplore.ieee.org/xpl/conhome/914230...</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/2020</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020 IEEE/CVF Conference on Computer Vision an...</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>IEEE</td>\n",
       "      <td>2020</td>\n",
       "      <td>Editorship</td>\n",
       "      <td>conf/cvpr/2020w</td>\n",
       "      <td>https://ieeexplore.ieee.org/xpl/conhome/914228...</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/2020w</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NTIRE 2020 Challenge on Real Image Denoising -...</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/AbdelhamedATBCZ20</td>\n",
       "      <td>https://doi.org/10.1109/CVPRW50498.2020.00256</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/AbdelhamedATBCZ20</td>\n",
       "      <td>[Abdelrahman Abdelhamed, Mahmoud Afifi, Radu T...</td>\n",
       "      <td>2077-2088</td>\n",
       "      <td>10.1109/CVPRW50498.2020.00256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NTIRE 2020 Challenge on NonHomogeneous Dehazing.</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/AncutiAVTLWXQMH20</td>\n",
       "      <td>https://doi.org/10.1109/CVPRW50498.2020.00253</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/AncutiAVTLWXQMH20</td>\n",
       "      <td>[Codruta O. Ancuti, Cosmin Ancuti, Florin-Alex...</td>\n",
       "      <td>2029-2044</td>\n",
       "      <td>10.1109/CVPRW50498.2020.00253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NTIRE 2020 Challenge on Spectral Reconstructio...</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/AradTBLFGLW0LLL20</td>\n",
       "      <td>https://doi.org/10.1109/CVPRW50498.2020.00231</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/AradTBLFGLW0LLL20</td>\n",
       "      <td>[Boaz Arad, Radu Timofte, Ohad Ben-Shahar, Yi-...</td>\n",
       "      <td>1806-1822</td>\n",
       "      <td>10.1109/CVPRW50498.2020.00231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1991</th>\n",
       "      <td>CVPR 2019 WAD Challenge on Trajectory Predicti...</td>\n",
       "      <td>[CoRR]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Informal Publications</td>\n",
       "      <td>journals/corr/abs-2004-05966</td>\n",
       "      <td>https://arxiv.org/abs/2004.05966</td>\n",
       "      <td>https://dblp.org/rec/journals/corr/abs-2004-05966</td>\n",
       "      <td>[Sibo Zhang, Yuexin Ma, Ruigang Yang, Xin Li, ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1992</th>\n",
       "      <td>Priming Neural Networks.</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/RosenfeldBT18</td>\n",
       "      <td>http://openaccess.thecvf.com/content_cvpr_2018...</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/RosenfeldBT18</td>\n",
       "      <td>[Amir Rosenfeld, Mahdi Biparva, John K. Tsotsos]</td>\n",
       "      <td>2011-2020</td>\n",
       "      <td>10.1109/CVPRW.2018.00270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1993</th>\n",
       "      <td>Superpixel meshes for fast edge-preserving sur...</td>\n",
       "      <td>[CVPR]</td>\n",
       "      <td>None</td>\n",
       "      <td>2015</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/Bodis-SzomoruRG15</td>\n",
       "      <td>https://doi.org/10.1109/CVPR.2015.7298812</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/Bodis-SzomoruRG15</td>\n",
       "      <td>[András Bódis-Szomorú, Hayko Riemenschneider, ...</td>\n",
       "      <td>2011-2020</td>\n",
       "      <td>10.1109/CVPR.2015.7298812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994</th>\n",
       "      <td>Multiphase geometric couplings for the segment...</td>\n",
       "      <td>[CVPR]</td>\n",
       "      <td>None</td>\n",
       "      <td>2009</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/ReinaMP09</td>\n",
       "      <td>https://doi.org/10.1109/CVPR.2009.5206524</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/ReinaMP09</td>\n",
       "      <td>[Amelio Vázquez Reina, Eric L. Miller 0001, Ha...</td>\n",
       "      <td>2020-2027</td>\n",
       "      <td>10.1109/CVPR.2009.5206524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>Integrating Shape from Shading and Range Data ...</td>\n",
       "      <td>[CVPR]</td>\n",
       "      <td>None</td>\n",
       "      <td>1999</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/MostafaYF99</td>\n",
       "      <td>https://doi.org/10.1109/CVPR.1999.784602</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/MostafaYF99</td>\n",
       "      <td>[Mostafa Gadal-Haqq M. Mostafa, Sameh M. Yaman...</td>\n",
       "      <td>2015-2020</td>\n",
       "      <td>10.1109/CVPR.1999.784602</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1996 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title             venue  \\\n",
       "0     2020 IEEE/CVF Conference on Computer Vision an...            [CVPR]   \n",
       "1     2020 IEEE/CVF Conference on Computer Vision an...  [CVPR Workshops]   \n",
       "2     NTIRE 2020 Challenge on Real Image Denoising -...  [CVPR Workshops]   \n",
       "3      NTIRE 2020 Challenge on NonHomogeneous Dehazing.  [CVPR Workshops]   \n",
       "4     NTIRE 2020 Challenge on Spectral Reconstructio...  [CVPR Workshops]   \n",
       "...                                                 ...               ...   \n",
       "1991  CVPR 2019 WAD Challenge on Trajectory Predicti...            [CoRR]   \n",
       "1992                           Priming Neural Networks.  [CVPR Workshops]   \n",
       "1993  Superpixel meshes for fast edge-preserving sur...            [CVPR]   \n",
       "1994  Multiphase geometric couplings for the segment...            [CVPR]   \n",
       "1995  Integrating Shape from Shading and Range Data ...            [CVPR]   \n",
       "\n",
       "     publisher  year                            type  \\\n",
       "0         IEEE  2020                      Editorship   \n",
       "1         IEEE  2020                      Editorship   \n",
       "2         None  2020  Conference and Workshop Papers   \n",
       "3         None  2020  Conference and Workshop Papers   \n",
       "4         None  2020  Conference and Workshop Papers   \n",
       "...        ...   ...                             ...   \n",
       "1991      None  2020           Informal Publications   \n",
       "1992      None  2018  Conference and Workshop Papers   \n",
       "1993      None  2015  Conference and Workshop Papers   \n",
       "1994      None  2009  Conference and Workshop Papers   \n",
       "1995      None  1999  Conference and Workshop Papers   \n",
       "\n",
       "                               key  \\\n",
       "0                   conf/cvpr/2020   \n",
       "1                  conf/cvpr/2020w   \n",
       "2      conf/cvpr/AbdelhamedATBCZ20   \n",
       "3      conf/cvpr/AncutiAVTLWXQMH20   \n",
       "4      conf/cvpr/AradTBLFGLW0LLL20   \n",
       "...                            ...   \n",
       "1991  journals/corr/abs-2004-05966   \n",
       "1992       conf/cvpr/RosenfeldBT18   \n",
       "1993   conf/cvpr/Bodis-SzomoruRG15   \n",
       "1994           conf/cvpr/ReinaMP09   \n",
       "1995         conf/cvpr/MostafaYF99   \n",
       "\n",
       "                                                     ee  \\\n",
       "0     https://ieeexplore.ieee.org/xpl/conhome/914230...   \n",
       "1     https://ieeexplore.ieee.org/xpl/conhome/914228...   \n",
       "2         https://doi.org/10.1109/CVPRW50498.2020.00256   \n",
       "3         https://doi.org/10.1109/CVPRW50498.2020.00253   \n",
       "4         https://doi.org/10.1109/CVPRW50498.2020.00231   \n",
       "...                                                 ...   \n",
       "1991                   https://arxiv.org/abs/2004.05966   \n",
       "1992  http://openaccess.thecvf.com/content_cvpr_2018...   \n",
       "1993          https://doi.org/10.1109/CVPR.2015.7298812   \n",
       "1994          https://doi.org/10.1109/CVPR.2009.5206524   \n",
       "1995           https://doi.org/10.1109/CVPR.1999.784602   \n",
       "\n",
       "                                                    url  \\\n",
       "0                   https://dblp.org/rec/conf/cvpr/2020   \n",
       "1                  https://dblp.org/rec/conf/cvpr/2020w   \n",
       "2      https://dblp.org/rec/conf/cvpr/AbdelhamedATBCZ20   \n",
       "3      https://dblp.org/rec/conf/cvpr/AncutiAVTLWXQMH20   \n",
       "4      https://dblp.org/rec/conf/cvpr/AradTBLFGLW0LLL20   \n",
       "...                                                 ...   \n",
       "1991  https://dblp.org/rec/journals/corr/abs-2004-05966   \n",
       "1992       https://dblp.org/rec/conf/cvpr/RosenfeldBT18   \n",
       "1993   https://dblp.org/rec/conf/cvpr/Bodis-SzomoruRG15   \n",
       "1994           https://dblp.org/rec/conf/cvpr/ReinaMP09   \n",
       "1995         https://dblp.org/rec/conf/cvpr/MostafaYF99   \n",
       "\n",
       "                                                authors      pages  \\\n",
       "0                                                  None       None   \n",
       "1                                                  None       None   \n",
       "2     [Abdelrahman Abdelhamed, Mahmoud Afifi, Radu T...  2077-2088   \n",
       "3     [Codruta O. Ancuti, Cosmin Ancuti, Florin-Alex...  2029-2044   \n",
       "4     [Boaz Arad, Radu Timofte, Ohad Ben-Shahar, Yi-...  1806-1822   \n",
       "...                                                 ...        ...   \n",
       "1991  [Sibo Zhang, Yuexin Ma, Ruigang Yang, Xin Li, ...       None   \n",
       "1992   [Amir Rosenfeld, Mahdi Biparva, John K. Tsotsos]  2011-2020   \n",
       "1993  [András Bódis-Szomorú, Hayko Riemenschneider, ...  2011-2020   \n",
       "1994  [Amelio Vázquez Reina, Eric L. Miller 0001, Ha...  2020-2027   \n",
       "1995  [Mostafa Gadal-Haqq M. Mostafa, Sameh M. Yaman...  2015-2020   \n",
       "\n",
       "                                doi  \n",
       "0                              None  \n",
       "1                              None  \n",
       "2     10.1109/CVPRW50498.2020.00256  \n",
       "3     10.1109/CVPRW50498.2020.00253  \n",
       "4     10.1109/CVPRW50498.2020.00231  \n",
       "...                             ...  \n",
       "1991                           None  \n",
       "1992       10.1109/CVPRW.2018.00270  \n",
       "1993      10.1109/CVPR.2015.7298812  \n",
       "1994      10.1109/CVPR.2009.5206524  \n",
       "1995       10.1109/CVPR.1999.784602  \n",
       "\n",
       "[1996 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from dataprep.connector import connect\n",
    "conn = connect(\"dblp\")\n",
    "df = await conn.query(\"publication\", q=\"CVPR 2020\", _count=2000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>venue</th>\n",
       "      <th>publisher</th>\n",
       "      <th>year</th>\n",
       "      <th>type</th>\n",
       "      <th>key</th>\n",
       "      <th>ee</th>\n",
       "      <th>url</th>\n",
       "      <th>authors</th>\n",
       "      <th>pages</th>\n",
       "      <th>doi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020 IEEE/CVF Conference on Computer Vision an...</td>\n",
       "      <td>[CVPR]</td>\n",
       "      <td>IEEE</td>\n",
       "      <td>2020</td>\n",
       "      <td>Editorship</td>\n",
       "      <td>conf/cvpr/2020</td>\n",
       "      <td>https://ieeexplore.ieee.org/xpl/conhome/914230...</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/2020</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020 IEEE/CVF Conference on Computer Vision an...</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>IEEE</td>\n",
       "      <td>2020</td>\n",
       "      <td>Editorship</td>\n",
       "      <td>conf/cvpr/2020w</td>\n",
       "      <td>https://ieeexplore.ieee.org/xpl/conhome/914228...</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/2020w</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NTIRE 2020 Challenge on Real Image Denoising -...</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/AbdelhamedATBCZ20</td>\n",
       "      <td>https://doi.org/10.1109/CVPRW50498.2020.00256</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/AbdelhamedATBCZ20</td>\n",
       "      <td>[Abdelrahman Abdelhamed, Mahmoud Afifi, Radu T...</td>\n",
       "      <td>2077-2088</td>\n",
       "      <td>10.1109/CVPRW50498.2020.00256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NTIRE 2020 Challenge on NonHomogeneous Dehazing.</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/AncutiAVTLWXQMH20</td>\n",
       "      <td>https://doi.org/10.1109/CVPRW50498.2020.00253</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/AncutiAVTLWXQMH20</td>\n",
       "      <td>[Codruta O. Ancuti, Cosmin Ancuti, Florin-Alex...</td>\n",
       "      <td>2029-2044</td>\n",
       "      <td>10.1109/CVPRW50498.2020.00253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NTIRE 2020 Challenge on Spectral Reconstructio...</td>\n",
       "      <td>[CVPR Workshops]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/cvpr/AradTBLFGLW0LLL20</td>\n",
       "      <td>https://doi.org/10.1109/CVPRW50498.2020.00231</td>\n",
       "      <td>https://dblp.org/rec/conf/cvpr/AradTBLFGLW0LLL20</td>\n",
       "      <td>[Boaz Arad, Radu Timofte, Ohad Ben-Shahar, Yi-...</td>\n",
       "      <td>1806-1822</td>\n",
       "      <td>10.1109/CVPRW50498.2020.00231</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title             venue  \\\n",
       "0  2020 IEEE/CVF Conference on Computer Vision an...            [CVPR]   \n",
       "1  2020 IEEE/CVF Conference on Computer Vision an...  [CVPR Workshops]   \n",
       "2  NTIRE 2020 Challenge on Real Image Denoising -...  [CVPR Workshops]   \n",
       "3   NTIRE 2020 Challenge on NonHomogeneous Dehazing.  [CVPR Workshops]   \n",
       "4  NTIRE 2020 Challenge on Spectral Reconstructio...  [CVPR Workshops]   \n",
       "\n",
       "  publisher  year                            type  \\\n",
       "0      IEEE  2020                      Editorship   \n",
       "1      IEEE  2020                      Editorship   \n",
       "2      None  2020  Conference and Workshop Papers   \n",
       "3      None  2020  Conference and Workshop Papers   \n",
       "4      None  2020  Conference and Workshop Papers   \n",
       "\n",
       "                           key  \\\n",
       "0               conf/cvpr/2020   \n",
       "1              conf/cvpr/2020w   \n",
       "2  conf/cvpr/AbdelhamedATBCZ20   \n",
       "3  conf/cvpr/AncutiAVTLWXQMH20   \n",
       "4  conf/cvpr/AradTBLFGLW0LLL20   \n",
       "\n",
       "                                                  ee  \\\n",
       "0  https://ieeexplore.ieee.org/xpl/conhome/914230...   \n",
       "1  https://ieeexplore.ieee.org/xpl/conhome/914228...   \n",
       "2      https://doi.org/10.1109/CVPRW50498.2020.00256   \n",
       "3      https://doi.org/10.1109/CVPRW50498.2020.00253   \n",
       "4      https://doi.org/10.1109/CVPRW50498.2020.00231   \n",
       "\n",
       "                                                url  \\\n",
       "0               https://dblp.org/rec/conf/cvpr/2020   \n",
       "1              https://dblp.org/rec/conf/cvpr/2020w   \n",
       "2  https://dblp.org/rec/conf/cvpr/AbdelhamedATBCZ20   \n",
       "3  https://dblp.org/rec/conf/cvpr/AncutiAVTLWXQMH20   \n",
       "4  https://dblp.org/rec/conf/cvpr/AradTBLFGLW0LLL20   \n",
       "\n",
       "                                             authors      pages  \\\n",
       "0                                               None       None   \n",
       "1                                               None       None   \n",
       "2  [Abdelrahman Abdelhamed, Mahmoud Afifi, Radu T...  2077-2088   \n",
       "3  [Codruta O. Ancuti, Cosmin Ancuti, Florin-Alex...  2029-2044   \n",
       "4  [Boaz Arad, Radu Timofte, Ohad Ben-Shahar, Yi-...  1806-1822   \n",
       "\n",
       "                             doi  \n",
       "0                           None  \n",
       "1                           None  \n",
       "2  10.1109/CVPRW50498.2020.00256  \n",
       "3  10.1109/CVPRW50498.2020.00253  \n",
       "4  10.1109/CVPRW50498.2020.00231  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Functionalities\n",
    "\n",
    "Connector has several functions you can perform to gain insight on the data downloaded from DBLP."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Connector.info\n",
    "The info method gives information and guidelines on using the connector. There are 4 sections in the response and they are table, parameters, example and schema.\n",
    "\n",
    ">1. Table - The table(s) being accessed.\n",
    ">2. Parameters - Identifies which parameters can be used to call the method.\n",
    ">3. Examples - Shows how you can call the methods in the Connector class.\n",
    ">4. Schema - Names and data types of attributes in the response."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<html>\n",
       "    <head>\n",
       "        <title> DataPrep.Connector Info </title>\n",
       "        <script>\n",
       "            function switchTab637(e) {\n",
       "                const selectedAreaSuffix = e.parentElement.parentElement.className.split('-')[1];\n",
       "                const selectedTabId = e.id.split('-')[2];\n",
       "                const selectedTabContent = document.querySelector(`.contents-${selectedAreaSuffix}>div:nth-of-type(${selectedTabId})`);\n",
       "                const contentArray = document.getElementsByClassName('info-637')\n",
       "                for (let i of contentArray) {\n",
       "                    i.style.display = 'none';\n",
       "                }\n",
       "                selectedTabContent.style.display = 'block';\n",
       "            }\n",
       "        </script>\n",
       "        <style>\n",
       "            .container-637 {\n",
       "            }\n",
       "            .container-637 input[type=radio] {\n",
       "            display: none;\n",
       "            }\n",
       "            .tabs-637 {\n",
       "            font-family: -apple-system, 'Helvetica Neue', 'Helvetica', 'Arial', 'Lucida Grande', sans-serif;\n",
       "            -webkit-font-smoothing: antialiased;\n",
       "            display: grid;\n",
       "            flex-wrap: wrap;\n",
       "            gap: 5px;\n",
       "            grid-template-columns: repeat(auto-fill, minmax(110px, 1fr));\n",
       "            justify-content: wrap;\n",
       "            }\n",
       "            .tabs-637 label {\n",
       "            word-wrap: break-word;\n",
       "            text-align: center;\n",
       "            font-size: 12px;\n",
       "            border-bottom: 2px solid #9edae5;\n",
       "            transition: border 0.3s ease;\n",
       "            }\n",
       "            .tabs-637 label:hover {\n",
       "            background: rgba(0, 0, 0, 0.1);\n",
       "            }\n",
       "            .tabs-637 input:checked+label {\n",
       "            border-bottom: 2px solid #1f77b4;\n",
       "            }\n",
       "            .contents-637>div:nth-of-type(n+2) {\n",
       "            display: none;\n",
       "            }\n",
       "            h4 {\n",
       "            font-size: 14px;\n",
       "            font-family: Arial;\n",
       "            }\n",
       "            p {\n",
       "            font-size: 13px;\n",
       "            }\n",
       "        </style>\n",
       "    </head>\n",
       "    <body>\n",
       "        <div class=\"container-637\">\n",
       "            <div class=\"tabs-637\">\n",
       "                <input type=\"radio\" name=\"select\" id='tab-637-1' checked onclick=\"switchTab637(this)\">\n",
       "                <label for=\"tab-637-1\">publication</label>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    \t\t\n",
       "            </div>\n",
       "            <div class=\"contents-637\">\n",
       "                \n",
       "                <div class=\"info-637\">\n",
       "                    <div>\n",
       "                        <h4><u>Parameters</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>q (required)</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>h</code></p>\n",
       "                        \n",
       "                        <p style=\"display:wrap\"><code>f</code></p>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                    </div>\n",
       "                    <div>\n",
       "                        <h4><u>Example</u></h4>\n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        \n",
       "                        <p><code>dc = connect('dblp')<br>df = await dc.query('publication', q='lee', _count=20)</code></p>\n",
       "                    </div>\n",
       "                    <div>\n",
       "                    \t<h4><u>Schema</u></h4>\n",
       "                    \t<style  type=\"text/css\" >\n",
       "    #T_93b151bc_805d_11eb_a9ad_acde48001122 th {\n",
       "          background: white;\n",
       "          font-weight: bold;\n",
       "          text-align: right;\n",
       "          font-family: arial;\n",
       "          font-size: 13;\n",
       "    }    #T_93b151bc_805d_11eb_a9ad_acde48001122 td {\n",
       "          font-family: arial;\n",
       "    }    #T_93b151bc_805d_11eb_a9ad_acde48001122 tr:nth-of-type(odd) {\n",
       "          background: #f5f5f5;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_93b151bc_805d_11eb_a9ad_acde48001122 tr:nth-of-type(even) {\n",
       "          background: #white;\n",
       "          font-size: 13;\n",
       "          text-align: right;\n",
       "    }    #T_93b151bc_805d_11eb_a9ad_acde48001122 tr:hover {\n",
       "          background-color: e0f1ff;\n",
       "    }</style><table id=\"T_93b151bc_805d_11eb_a9ad_acde48001122\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >column_name</th>        <th class=\"col_heading level0 col1\" >data_type</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row0_col0\" class=\"data row0 col0\" >title</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row0_col1\" class=\"data row0 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row1_col0\" class=\"data row1 col0\" >venue</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row1_col1\" class=\"data row1 col1\" >object</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row2_col0\" class=\"data row2 col0\" >publisher</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row2_col1\" class=\"data row2 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row3_col0\" class=\"data row3 col0\" >year</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row3_col1\" class=\"data row3 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row4_col0\" class=\"data row4 col0\" >type</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row4_col1\" class=\"data row4 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row5_col0\" class=\"data row5 col0\" >key</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row5_col1\" class=\"data row5 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row6_col0\" class=\"data row6 col0\" >ee</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row6_col1\" class=\"data row6 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row7_col0\" class=\"data row7 col0\" >url</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row7_col1\" class=\"data row7 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row8_col0\" class=\"data row8 col0\" >authors</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row8_col1\" class=\"data row8 col1\" >object</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row9_col0\" class=\"data row9 col0\" >pages</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row9_col1\" class=\"data row9 col1\" >string</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_93b151bc_805d_11eb_a9ad_acde48001122level0_row10\" class=\"row_heading level0 row10\" >10</th>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row10_col0\" class=\"data row10 col0\" >doi</td>\n",
       "                        <td id=\"T_93b151bc_805d_11eb_a9ad_acde48001122row10_col1\" class=\"data row10 col1\" >string</td>\n",
       "            </tr>\n",
       "    </tbody></table>\n",
       "                    </div>\n",
       "                </div>\n",
       "                \n",
       "            </div>\n",
       "        </div>\n",
       "    </body>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "conn.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Connector.query\n",
    "The query method downloads the website data and displays it in a Dataframe. The parameters must meet the requirements as indicated in connector.info for the operation to run.\n",
    "\n",
    "When the data is received from the server, it will either be in a JSON or XML format. The connector reformats the data in pandas Dataframe for the convenience of downstream operations.\n",
    "\n",
    "As an example, let's try to get the data from the \"publication\" table, using \"lee\" as the query search."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>venue</th>\n",
       "      <th>publisher</th>\n",
       "      <th>year</th>\n",
       "      <th>type</th>\n",
       "      <th>key</th>\n",
       "      <th>ee</th>\n",
       "      <th>url</th>\n",
       "      <th>authors</th>\n",
       "      <th>pages</th>\n",
       "      <th>doi</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22.3 A 128Gb 8-High 512GB/s HBM2E DRAM with a ...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/LeeCKKOKKLKYKLL20</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC19947.2020.9062977</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/LeeCKKOKKLKYKLL20</td>\n",
       "      <td>[Dong-Uk Lee, Ho Sung Cho, Jihwan Kim, Young J...</td>\n",
       "      <td>334-336</td>\n",
       "      <td>10.1109/ISSCC19947.2020.9062977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Comparison and analysis of scan matching techn...</td>\n",
       "      <td>[URAI]</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/urai/LeeLLLKPLL11</td>\n",
       "      <td>https://doi.org/10.1109/URAI.2011.6145953</td>\n",
       "      <td>https://dblp.org/rec/conf/urai/LeeLLLKPLL11</td>\n",
       "      <td>[Heon-Cheol Lee, Seung-Hee Lee, Seung-Hwan Lee...</td>\n",
       "      <td>165-168</td>\n",
       "      <td>10.1109/URAI.2011.6145953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A 1.6V 3.3Gb/s GDDR3 DRAM with dual-mode phase...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2009</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/LeeYCCLKKYKLLSKCSSMKLPKCAC09</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2009.4977347</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/LeeYCCLKKYKLLS...</td>\n",
       "      <td>[Hyun-Woo Lee, Won-Joo Yun, Young-Kyoung Choi,...</td>\n",
       "      <td>140-141</td>\n",
       "      <td>10.1109/ISSCC.2009.4977347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Managing Fault Tolerance Information in Multi-...</td>\n",
       "      <td>[IDEAL]</td>\n",
       "      <td>None</td>\n",
       "      <td>2003</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/ideal/LeeCLPLYL03</td>\n",
       "      <td>https://doi.org/10.1007/978-3-540-45080-1_15</td>\n",
       "      <td>https://dblp.org/rec/conf/ideal/LeeCLPLYL03</td>\n",
       "      <td>[Dae-Won Lee, Kwang-Sik Chung, Hwa-Min Lee, Su...</td>\n",
       "      <td>104-108</td>\n",
       "      <td>10.1007/978-3-540-45080-1_15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>22.1 A 1.1V 16GB 640GB/s HBM2E DRAM with a Dat...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/OhCBKKRPKCSLSHC20</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC19947.2020.9063110</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/OhCBKKRPKCSLSHC20</td>\n",
       "      <td>[Chi-Sung Oh, Ki Chul Chun, Young-Yong Byun, Y...</td>\n",
       "      <td>330-332</td>\n",
       "      <td>10.1109/ISSCC19947.2020.9063110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A 1.8 Gb/s/pin 16Tb NAND Flash Memory Multi-Ch...</td>\n",
       "      <td>[VLSI Circuits]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/vlsic/LeeNKCLYSKLJCJJ20</td>\n",
       "      <td>https://doi.org/10.1109/VLSICircuits18222.2020...</td>\n",
       "      <td>https://dblp.org/rec/conf/vlsic/LeeNKCLYSKLJCJJ20</td>\n",
       "      <td>[Jang-Woo Lee, Dae-Hoon Na, Anil Kavala, Hwasu...</td>\n",
       "      <td>1-2</td>\n",
       "      <td>10.1109/VLSICIRCUITS18222.2020.9163052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>A 16Gb 18Gb/S/pin GDDR6 DRAM with per-bit trai...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/KimKDEKAKJDLKKP18</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2018.8310255</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/KimKDEKAKJDLKKP18</td>\n",
       "      <td>[Young-Ju Kim 0001, Hye-Jung Kwon, Su-Yeon Doo...</td>\n",
       "      <td>204-206</td>\n",
       "      <td>10.1109/ISSCC.2018.8310255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>OGSA-GFS - A OGSA based Grid File System.</td>\n",
       "      <td>[SKG]</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/skg/ChinLLLYL05</td>\n",
       "      <td>https://doi.org/10.1109/SKG.2005.97</td>\n",
       "      <td>https://dblp.org/rec/conf/skg/ChinLLLYL05</td>\n",
       "      <td>[Sung-Ho Chin, Jong-Hyuk Lee, Hwa-Min Lee, Dae...</td>\n",
       "      <td>89</td>\n",
       "      <td>10.1109/SKG.2005.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>An RF Transceiver with Full Digital Interface ...</td>\n",
       "      <td>[VLSI Circuits]</td>\n",
       "      <td>None</td>\n",
       "      <td>2020</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/vlsic/HanJLJLLLHLBCLK20</td>\n",
       "      <td>https://doi.org/10.1109/VLSICircuits18222.2020...</td>\n",
       "      <td>https://dblp.org/rec/conf/vlsic/HanJLJLLLHLBCLK20</td>\n",
       "      <td>[Sangwook Han, Jaehyuk Jang, Jaeseung Lee, Dae...</td>\n",
       "      <td>1-2</td>\n",
       "      <td>10.1109/VLSICIRCUITS18222.2020.9162850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>A 16Gb 1.2V 3.2Gb/s/pin DDR4 SDRAM with improv...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2018</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/ShimKBKLKKLHKPK18</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2018.8310259</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/ShimKBKLKKLHKPK18</td>\n",
       "      <td>[Seokbo Shim, Sungho Kim, Jooyoung Bae, Keunsi...</td>\n",
       "      <td>212-214</td>\n",
       "      <td>10.1109/ISSCC.2018.8310259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11.4 A 512Gb 3b/cell 64-stacked WL 3D V-NAND f...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2017</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/KimCJPPKKLLKPAL17</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2017.7870331</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/KimCJPPKKLLKPAL17</td>\n",
       "      <td>[Chulbum Kim, Ji-Ho Cho, Woopyo Jeong, Il-Han ...</td>\n",
       "      <td>202-203</td>\n",
       "      <td>10.1109/ISSCC.2017.7870331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>23.4 An extremely low-standby-power 3.733Gb/s/...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2017</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/KwonSLSHKLJDCPD17</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2017.7870427</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/KwonSLSHKLJDCPD17</td>\n",
       "      <td>[Hye-Jung Kwon, Eunsung Seo, ChangYong Lee, Yo...</td>\n",
       "      <td>394-395</td>\n",
       "      <td>10.1109/ISSCC.2017.7870427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7.5 A 128Gb 2b/cell NAND flash memory in 14nm ...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/LeeLPPYKLKLKCCY16</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2016.7417945</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/LeeLPPYKLKLKCCY16</td>\n",
       "      <td>[Seungjae Lee, Jin-Yub Lee, Il-Han Park, Jong-...</td>\n",
       "      <td>138-139</td>\n",
       "      <td>10.1109/ISSCC.2016.7417945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Functional activity mapping of rat auditory pa...</td>\n",
       "      <td>[NeuroImage]</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>Journal Articles</td>\n",
       "      <td>journals/neuroimage/LeeYLSHJLLCC12</td>\n",
       "      <td>https://doi.org/10.1016/j.neuroimage.2012.01.065</td>\n",
       "      <td>https://dblp.org/rec/journals/neuroimage/LeeYL...</td>\n",
       "      <td>[Hui Joong Lee, Seung-Jun Yoo, Sang-Heun Lee, ...</td>\n",
       "      <td>1046-1054</td>\n",
       "      <td>10.1016/J.NEUROIMAGE.2012.01.065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>A Robotic Pan and Tilt 3-D Target Tracking Sys...</td>\n",
       "      <td>[ICIRA]</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/icira/KimBLLJLMC12</td>\n",
       "      <td>https://doi.org/10.1007/978-3-642-33515-0_66</td>\n",
       "      <td>https://dblp.org/rec/conf/icira/KimBLLJLMC12</td>\n",
       "      <td>[Tae-il Kim, Wook Bahn, Chang-hun Lee, Tae-Jae...</td>\n",
       "      <td>676-685</td>\n",
       "      <td>10.1007/978-3-642-33515-0_66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Wavelength initialization technique for colorl...</td>\n",
       "      <td>[ICTC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/ictc/JungLMLWLH12</td>\n",
       "      <td>https://doi.org/10.1109/ICTC.2012.6387204</td>\n",
       "      <td>https://dblp.org/rec/conf/ictc/JungLMLWLH12</td>\n",
       "      <td>[Eui-Suk Jung, Eun-Gu Lee, Sil-Gu Mun, Jong Hy...</td>\n",
       "      <td>579-580</td>\n",
       "      <td>10.1109/ICTC.2012.6387204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Booting process technology for wavelength init...</td>\n",
       "      <td>[ICTC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/ictc/LeeMJLL12</td>\n",
       "      <td>https://doi.org/10.1109/ICTC.2012.6387150</td>\n",
       "      <td>https://dblp.org/rec/conf/ictc/LeeMJLL12</td>\n",
       "      <td>[Eun-Gu Lee, Sil-Gu Mun, Eui-Suk Jung, Jong Hy...</td>\n",
       "      <td>807-808</td>\n",
       "      <td>10.1109/ICTC.2012.6387150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>RFID sensor deployment using differential evol...</td>\n",
       "      <td>[IROS]</td>\n",
       "      <td>None</td>\n",
       "      <td>2010</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/iros/SeokLOLL10</td>\n",
       "      <td>https://doi.org/10.1109/IROS.2010.5651580</td>\n",
       "      <td>https://dblp.org/rec/conf/iros/SeokLOLL10</td>\n",
       "      <td>[Joon-Hong Seok, Joon-Yong Lee, Changmok Oh, J...</td>\n",
       "      <td>3719-3724</td>\n",
       "      <td>10.1109/IROS.2010.5651580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Reusable Electrical Activity of the Heart Moni...</td>\n",
       "      <td>[J. Medical Syst.]</td>\n",
       "      <td>None</td>\n",
       "      <td>2009</td>\n",
       "      <td>Journal Articles</td>\n",
       "      <td>journals/jms/LeeLLHKKLL09</td>\n",
       "      <td>https://doi.org/10.1007/s10916-008-9162-8</td>\n",
       "      <td>https://dblp.org/rec/journals/jms/LeeLLHKKLL09</td>\n",
       "      <td>[Jeong-Whan Lee, Kang-Hwi Lee, Young-Jae Lee, ...</td>\n",
       "      <td>41-46</td>\n",
       "      <td>10.1007/S10916-008-9162-8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Multi-Slew-Rate Output Driver and Optimized Im...</td>\n",
       "      <td>[ISSCC]</td>\n",
       "      <td>None</td>\n",
       "      <td>2008</td>\n",
       "      <td>Conference and Workshop Papers</td>\n",
       "      <td>conf/isscc/LeeKPLCLKLYSKCY08</td>\n",
       "      <td>https://doi.org/10.1109/ISSCC.2008.4523166</td>\n",
       "      <td>https://dblp.org/rec/conf/isscc/LeeKPLCLKLYSKCY08</td>\n",
       "      <td>[Dong-Uk Lee, Shin-Deok Kang, Nak-Kyu Park, Hy...</td>\n",
       "      <td>280-281</td>\n",
       "      <td>10.1109/ISSCC.2008.4523166</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title               venue  \\\n",
       "0   22.3 A 128Gb 8-High 512GB/s HBM2E DRAM with a ...             [ISSCC]   \n",
       "1   Comparison and analysis of scan matching techn...              [URAI]   \n",
       "2   A 1.6V 3.3Gb/s GDDR3 DRAM with dual-mode phase...             [ISSCC]   \n",
       "3   Managing Fault Tolerance Information in Multi-...             [IDEAL]   \n",
       "4   22.1 A 1.1V 16GB 640GB/s HBM2E DRAM with a Dat...             [ISSCC]   \n",
       "5   A 1.8 Gb/s/pin 16Tb NAND Flash Memory Multi-Ch...     [VLSI Circuits]   \n",
       "6   A 16Gb 18Gb/S/pin GDDR6 DRAM with per-bit trai...             [ISSCC]   \n",
       "7           OGSA-GFS - A OGSA based Grid File System.               [SKG]   \n",
       "8   An RF Transceiver with Full Digital Interface ...     [VLSI Circuits]   \n",
       "9   A 16Gb 1.2V 3.2Gb/s/pin DDR4 SDRAM with improv...             [ISSCC]   \n",
       "10  11.4 A 512Gb 3b/cell 64-stacked WL 3D V-NAND f...             [ISSCC]   \n",
       "11  23.4 An extremely low-standby-power 3.733Gb/s/...             [ISSCC]   \n",
       "12  7.5 A 128Gb 2b/cell NAND flash memory in 14nm ...             [ISSCC]   \n",
       "13  Functional activity mapping of rat auditory pa...        [NeuroImage]   \n",
       "14  A Robotic Pan and Tilt 3-D Target Tracking Sys...             [ICIRA]   \n",
       "15  Wavelength initialization technique for colorl...              [ICTC]   \n",
       "16  Booting process technology for wavelength init...              [ICTC]   \n",
       "17  RFID sensor deployment using differential evol...              [IROS]   \n",
       "18  Reusable Electrical Activity of the Heart Moni...  [J. Medical Syst.]   \n",
       "19  Multi-Slew-Rate Output Driver and Optimized Im...             [ISSCC]   \n",
       "\n",
       "   publisher  year                            type  \\\n",
       "0       None  2020  Conference and Workshop Papers   \n",
       "1       None  2011  Conference and Workshop Papers   \n",
       "2       None  2009  Conference and Workshop Papers   \n",
       "3       None  2003  Conference and Workshop Papers   \n",
       "4       None  2020  Conference and Workshop Papers   \n",
       "5       None  2020  Conference and Workshop Papers   \n",
       "6       None  2018  Conference and Workshop Papers   \n",
       "7       None  2005  Conference and Workshop Papers   \n",
       "8       None  2020  Conference and Workshop Papers   \n",
       "9       None  2018  Conference and Workshop Papers   \n",
       "10      None  2017  Conference and Workshop Papers   \n",
       "11      None  2017  Conference and Workshop Papers   \n",
       "12      None  2016  Conference and Workshop Papers   \n",
       "13      None  2012                Journal Articles   \n",
       "14      None  2012  Conference and Workshop Papers   \n",
       "15      None  2012  Conference and Workshop Papers   \n",
       "16      None  2012  Conference and Workshop Papers   \n",
       "17      None  2010  Conference and Workshop Papers   \n",
       "18      None  2009                Journal Articles   \n",
       "19      None  2008  Conference and Workshop Papers   \n",
       "\n",
       "                                        key  \\\n",
       "0              conf/isscc/LeeCKKOKKLKYKLL20   \n",
       "1                    conf/urai/LeeLLLKPLL11   \n",
       "2   conf/isscc/LeeYCCLKKYKLLSKCSSMKLPKCAC09   \n",
       "3                    conf/ideal/LeeCLPLYL03   \n",
       "4              conf/isscc/OhCBKKRPKCSLSHC20   \n",
       "5              conf/vlsic/LeeNKCLYSKLJCJJ20   \n",
       "6              conf/isscc/KimKDEKAKJDLKKP18   \n",
       "7                      conf/skg/ChinLLLYL05   \n",
       "8              conf/vlsic/HanJLJLLLHLBCLK20   \n",
       "9              conf/isscc/ShimKBKLKKLHKPK18   \n",
       "10             conf/isscc/KimCJPPKKLLKPAL17   \n",
       "11             conf/isscc/KwonSLSHKLJDCPD17   \n",
       "12             conf/isscc/LeeLPPYKLKLKCCY16   \n",
       "13       journals/neuroimage/LeeYLSHJLLCC12   \n",
       "14                  conf/icira/KimBLLJLMC12   \n",
       "15                   conf/ictc/JungLMLWLH12   \n",
       "16                      conf/ictc/LeeMJLL12   \n",
       "17                     conf/iros/SeokLOLL10   \n",
       "18                journals/jms/LeeLLHKKLL09   \n",
       "19             conf/isscc/LeeKPLCLKLYSKCY08   \n",
       "\n",
       "                                                   ee  \\\n",
       "0     https://doi.org/10.1109/ISSCC19947.2020.9062977   \n",
       "1           https://doi.org/10.1109/URAI.2011.6145953   \n",
       "2          https://doi.org/10.1109/ISSCC.2009.4977347   \n",
       "3        https://doi.org/10.1007/978-3-540-45080-1_15   \n",
       "4     https://doi.org/10.1109/ISSCC19947.2020.9063110   \n",
       "5   https://doi.org/10.1109/VLSICircuits18222.2020...   \n",
       "6          https://doi.org/10.1109/ISSCC.2018.8310255   \n",
       "7                 https://doi.org/10.1109/SKG.2005.97   \n",
       "8   https://doi.org/10.1109/VLSICircuits18222.2020...   \n",
       "9          https://doi.org/10.1109/ISSCC.2018.8310259   \n",
       "10         https://doi.org/10.1109/ISSCC.2017.7870331   \n",
       "11         https://doi.org/10.1109/ISSCC.2017.7870427   \n",
       "12         https://doi.org/10.1109/ISSCC.2016.7417945   \n",
       "13   https://doi.org/10.1016/j.neuroimage.2012.01.065   \n",
       "14       https://doi.org/10.1007/978-3-642-33515-0_66   \n",
       "15          https://doi.org/10.1109/ICTC.2012.6387204   \n",
       "16          https://doi.org/10.1109/ICTC.2012.6387150   \n",
       "17          https://doi.org/10.1109/IROS.2010.5651580   \n",
       "18          https://doi.org/10.1007/s10916-008-9162-8   \n",
       "19         https://doi.org/10.1109/ISSCC.2008.4523166   \n",
       "\n",
       "                                                  url  \\\n",
       "0   https://dblp.org/rec/conf/isscc/LeeCKKOKKLKYKLL20   \n",
       "1         https://dblp.org/rec/conf/urai/LeeLLLKPLL11   \n",
       "2   https://dblp.org/rec/conf/isscc/LeeYCCLKKYKLLS...   \n",
       "3         https://dblp.org/rec/conf/ideal/LeeCLPLYL03   \n",
       "4   https://dblp.org/rec/conf/isscc/OhCBKKRPKCSLSHC20   \n",
       "5   https://dblp.org/rec/conf/vlsic/LeeNKCLYSKLJCJJ20   \n",
       "6   https://dblp.org/rec/conf/isscc/KimKDEKAKJDLKKP18   \n",
       "7           https://dblp.org/rec/conf/skg/ChinLLLYL05   \n",
       "8   https://dblp.org/rec/conf/vlsic/HanJLJLLLHLBCLK20   \n",
       "9   https://dblp.org/rec/conf/isscc/ShimKBKLKKLHKPK18   \n",
       "10  https://dblp.org/rec/conf/isscc/KimCJPPKKLLKPAL17   \n",
       "11  https://dblp.org/rec/conf/isscc/KwonSLSHKLJDCPD17   \n",
       "12  https://dblp.org/rec/conf/isscc/LeeLPPYKLKLKCCY16   \n",
       "13  https://dblp.org/rec/journals/neuroimage/LeeYL...   \n",
       "14       https://dblp.org/rec/conf/icira/KimBLLJLMC12   \n",
       "15        https://dblp.org/rec/conf/ictc/JungLMLWLH12   \n",
       "16           https://dblp.org/rec/conf/ictc/LeeMJLL12   \n",
       "17          https://dblp.org/rec/conf/iros/SeokLOLL10   \n",
       "18     https://dblp.org/rec/journals/jms/LeeLLHKKLL09   \n",
       "19  https://dblp.org/rec/conf/isscc/LeeKPLCLKLYSKCY08   \n",
       "\n",
       "                                              authors      pages  \\\n",
       "0   [Dong-Uk Lee, Ho Sung Cho, Jihwan Kim, Young J...    334-336   \n",
       "1   [Heon-Cheol Lee, Seung-Hee Lee, Seung-Hwan Lee...    165-168   \n",
       "2   [Hyun-Woo Lee, Won-Joo Yun, Young-Kyoung Choi,...    140-141   \n",
       "3   [Dae-Won Lee, Kwang-Sik Chung, Hwa-Min Lee, Su...    104-108   \n",
       "4   [Chi-Sung Oh, Ki Chul Chun, Young-Yong Byun, Y...    330-332   \n",
       "5   [Jang-Woo Lee, Dae-Hoon Na, Anil Kavala, Hwasu...        1-2   \n",
       "6   [Young-Ju Kim 0001, Hye-Jung Kwon, Su-Yeon Doo...    204-206   \n",
       "7   [Sung-Ho Chin, Jong-Hyuk Lee, Hwa-Min Lee, Dae...         89   \n",
       "8   [Sangwook Han, Jaehyuk Jang, Jaeseung Lee, Dae...        1-2   \n",
       "9   [Seokbo Shim, Sungho Kim, Jooyoung Bae, Keunsi...    212-214   \n",
       "10  [Chulbum Kim, Ji-Ho Cho, Woopyo Jeong, Il-Han ...    202-203   \n",
       "11  [Hye-Jung Kwon, Eunsung Seo, ChangYong Lee, Yo...    394-395   \n",
       "12  [Seungjae Lee, Jin-Yub Lee, Il-Han Park, Jong-...    138-139   \n",
       "13  [Hui Joong Lee, Seung-Jun Yoo, Sang-Heun Lee, ...  1046-1054   \n",
       "14  [Tae-il Kim, Wook Bahn, Chang-hun Lee, Tae-Jae...    676-685   \n",
       "15  [Eui-Suk Jung, Eun-Gu Lee, Sil-Gu Mun, Jong Hy...    579-580   \n",
       "16  [Eun-Gu Lee, Sil-Gu Mun, Eui-Suk Jung, Jong Hy...    807-808   \n",
       "17  [Joon-Hong Seok, Joon-Yong Lee, Changmok Oh, J...  3719-3724   \n",
       "18  [Jeong-Whan Lee, Kang-Hwi Lee, Young-Jae Lee, ...      41-46   \n",
       "19  [Dong-Uk Lee, Shin-Deok Kang, Nak-Kyu Park, Hy...    280-281   \n",
       "\n",
       "                                       doi  \n",
       "0          10.1109/ISSCC19947.2020.9062977  \n",
       "1                10.1109/URAI.2011.6145953  \n",
       "2               10.1109/ISSCC.2009.4977347  \n",
       "3             10.1007/978-3-540-45080-1_15  \n",
       "4          10.1109/ISSCC19947.2020.9063110  \n",
       "5   10.1109/VLSICIRCUITS18222.2020.9163052  \n",
       "6               10.1109/ISSCC.2018.8310255  \n",
       "7                      10.1109/SKG.2005.97  \n",
       "8   10.1109/VLSICIRCUITS18222.2020.9162850  \n",
       "9               10.1109/ISSCC.2018.8310259  \n",
       "10              10.1109/ISSCC.2017.7870331  \n",
       "11              10.1109/ISSCC.2017.7870427  \n",
       "12              10.1109/ISSCC.2016.7417945  \n",
       "13        10.1016/J.NEUROIMAGE.2012.01.065  \n",
       "14            10.1007/978-3-642-33515-0_66  \n",
       "15               10.1109/ICTC.2012.6387204  \n",
       "16               10.1109/ICTC.2012.6387150  \n",
       "17               10.1109/IROS.2010.5651580  \n",
       "18               10.1007/S10916-008-9162-8  \n",
       "19              10.1109/ISSCC.2008.4523166  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = await conn.query('publication', q='lee', _count=20)\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "From query results, you can see how easy it is to download the publication data from DBLP into a pandas Dataframe.\n",
    "\n",
    "Now that you have an understanding of how connector operates, you can easily accomplish the task with two lines of code.\n",
    "\n",
    "\n",
    ">1. dc = Connector(...)\n",
    ">2. dc.query(...)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# That's all for now. \n",
    "If you are interested in writing your own configuration file or modify an existing one, refer to the [Configuration Files](https://github.com/sfu-db/DataConnectorConfigs>)."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
